INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'ALPHARETTA',
		'Alpharetta 230/25kV GPC',
		'Alpharetta 230/25kV GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.106.27:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'AMERICUS',
		'Americus DME GPC',
		'Americus DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.77.209:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'ATHENA',
		'Athena GPC DFR',
		'Athena GPC DFR',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.173.250:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'ATHENS',
		'Athens 115/46kV  DF/SE GPC',
		'Athens 115/46kV  DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.158.234:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'ATKINSON',
		'Atkinson 115kV DME GPC',
		'Atkinson 115kV DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.165.40:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'AUGUSTA_CP_PK',
		'Augusta Cp Pk 230/25  DF/SE  GPC',
		'Augusta Cp Pk 230/25  DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.104.125:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'AUGUSTA_NEWS',
		'Augusta News 230/13.8  DF/SE GPC',
		'Augusta News 230/13.8  DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.104.144:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'AUSTIN_DR',
		'Austin Dr 230/115 DF/SE  GPC',
		'Austin Dr 230/115 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.105.216:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'AVALON_JCT',
		'Avalon Jct 115 DF/SE  GPC',
		'Avalon Jct 115 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.106.61:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'BARTLETTS_FERRY',
		'Bartletts Ferry DF/SE GPC',
		'Bartletts Ferry DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.174.74:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'BAXLEY',
		'Baxley 115/46kV DME',
		'Baxley 115/46kV DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.105.45:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'BICKLEY_SS',
		'Bickley SS DME',
		'Bickley SS DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.83.51:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'BIO',
		'Bio 230/115 DF/SE  GPC',
		'Bio 230/115 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.76.214:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'BLANKETS_CRK',
		'Blanket''s Crk 230/115 DF/SE GPC',
		'Blanket''s Crk 230/115 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.76.244:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'BOULEVARD_ATL',
		'BOULEVARD (ATL) 230kV DME GPC',
		'BOULEVARD (ATL) 230kV DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.165.138:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'BOULEVARD_SAV',
		'Boulevard (Sav) DF/SE GPC',
		'Boulevard (Sav) DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.163.184:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'BRANCH',
		'Branch DF/SE GPC',
		'Branch DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.163.250:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'BRUNSWICK',
		'Brunswick DME GPC',
		'Brunswick DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.77.253:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'BULL_SLUICE_230',
		'BULL SLUICE 230kV',
		'BULL SLUICE 230kV',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.175.105:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'BULL_SLUICE_500',
		'BULL SLUICE 500kV',
		'BULL SLUICE 500kV',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.175.106:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'BUTLER',
		'Butler 230/115 DME  GPC',
		'Butler 230/115 DME  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.170.10:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'CARTERSVILLE',
		'Cartersville',
		'Cartersville',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.167.154:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'CLAXTON',
		'Claxton DME',
		'Claxton DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.112.87:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'CLERMONT_JUNCTION',
		'Clermont Junction GPC DME',
		'Clermont Junction GPC DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.76.246:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'COLERAIN',
		'Colerain 230/115 DF/SE  GPC',
		'Colerain 230/115 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.102.34:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'COMMERCE_PRIMARY',
		'Commerce Primary DME GPC',
		'Commerce Primary DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.171.10:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'CONYERS',
		'Conyers 230/115 DF/SE  GPC',
		'Conyers 230/115 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.168.42:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'CORNISH_MTN',
		'Cornish Mtn 230/115 DF/SE  GPC',
		'Cornish Mtn 230/115 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.105.217:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'COTTON_PRIMARY',
		'Cotton Primary',
		'Cotton Primary',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.102.14:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'CUMMING',
		'Cumming 230/115 DF/SE  GPC',
		'Cumming 230/115 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.106.15:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'DAISY',
		'Daisy DME',
		'Daisy DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.108.135:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'DALTON',
		'Dalton DS',
		'Dalton DS',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.79.156:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'DAVIS_STREET',
		'Davis Street DF/SE GPC',
		'Davis Street DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.162.218:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'DAWSON_CROSSING',
		'Dawson Crossing 230/115 DME GPC',
		'Dawson Crossing 230/115 DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.78.172:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'DEAN_FOREST',
		'Dean Forest DME GPC',
		'Dean Forest DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.164.218:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'DEPTFORD',
		'Deptford 115/46 DF/SE GPC',
		'Deptford 115/46 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.7.162.58:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'DERING_CIRCLE',
		'Dering Circle 230 DME',
		'Dering Circle 230 DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.163.10:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'DUBLIN',
		'Dublin DME',
		'Dublin DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.80.45:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'DUM_JON',
		'Dum Jon DME GPC',
		'Dum Jon DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.112.181:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'DYER_ROAD',
		'Dyer Road 230/115 DF/SE GPC',
		'Dyer Road 230/115 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.173.154:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'E.DALTON',
		'E.Dalton 230/115 DF/SE GPC',
		'E.Dalton 230/115 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.80.78:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'EAST_MOULTRIE',
		'East Moultrie 230/115kV DME',
		'East Moultrie 230/115kV DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.110.30:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'EAST_POINT',
		'East Point',
		'East Point',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.160.42:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'EATONTON',
		'Eatonton Pri DME GPC',
		'Eatonton Pri DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.106.99:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'EATONTON_PRIMARY',
		'Eatonton Primary',
		'Eatonton Primary',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.86.42216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'EVANS',
		'Evans 230/115 DF/SE GPC',
		'Evans 230/115 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.106.64:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'FACEVILLE',
		'Faceville DME',
		'Faceville DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.114.105:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'FIFTEENTH_STREET',
		'Fifteenth Street DME',
		'Fifteenth Street DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.156.201:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'FLINK_OVERLOOK',
		'Flink Overlook',
		'Flink Overlook',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.82.174:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'FORTSON_230/115_DF/SE_MEAG',
		'Fortson 230/115 DF/SE MEAG',
		'Fortson 230/115 DF/SE MEAG',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.164.202:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'FORTSON_500',
		'FORTSON 500KV DME',
		'FORTSON 500KV DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.156.169:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'FORTSON_500_DF/SE_MEAG',
		'Fortson 500 DF/SE MEAG',
		'Fortson 500 DF/SE MEAG',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.163.73:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'GAINESVILLE_1',
		'Gainesville #1 115/46kV DME GPC',
		'Gainesville #1 115/46kV DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.76.247:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'GAINESVILLE_2',
		'GAINESVILLE #2 DME GPC',
		'GAINESVILLE #2 DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.106.46:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'GERDAU',
		'Gerdau 230/34/13 DME GPC',
		'Gerdau 230/34/13 DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.110.202:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'GOAT_ROCK_115',
		'Goat Rock 115kV DF/SE GPC',
		'Goat Rock 115kV DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.164.70:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'GOAT_ROCK_230',
		'Goat Rock 230 DF/SE GPC',
		'Goat Rock 230 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.164.110:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'GOLDENS_CREEK',
		'Goldens Creek',
		'Goldens Creek',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.79.211:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'GOOSE_POND_ROAD',
		'Goose Pond Road DME',
		'Goose Pond Road DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.82.204:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'GORDON',
		'Gordon 230/115 DF/SE GPC',
		'Gordon 230/115 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.111.33:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'GRADY',
		'Grady DF/SE GPC',
		'Grady DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.163.215:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'HADDEN_POND',
		'Hadden Pond DME',
		'Hadden Pond DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.83.6:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'HAMMOND',
		'Hammond 230/115kV DF/SE GPC',
		'Hammond 230/115kV DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.112.174:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'HILL_STREET',
		'Hill Street 230/20kV GPC DME',
		'Hill Street 230/20kV GPC DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.161.122:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'HINESVILLE_PRIMARY',
		'Hinesville Primary 115/12kV DME',
		'Hinesville Primary 115/12kV DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.84.172:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'HOLLINGSWORTH_FERRY',
		'Hollingsworth Ferry',
		'Hollingsworth Ferry',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.172.154:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'HUYNDAI_MOTORS',
		'Huyndai Motors DME',
		'Huyndai Motors DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.84.39:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'KATHLEEN',
		'Kathleen 230/115 DF/SE  GPC',
		'Kathleen 230/115 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.113.181:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'KINGSLAND',
		'Kingsland 230/115kV DF/SE GPC',
		'Kingsland 230/115kV DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.155.90:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'KLONDIKE',
		'Klondike DME',
		'Klondike DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.175.57:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'KRAFT_115KV',
		'Kraft 115kV DF/SE GPC',
		'Kraft 115kV DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.16.89:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'KRAFT_230',
		'Kraft 230 DF/SE GPC',
		'Kraft 230 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.165.250:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'LAGRANGE',
		'LaGrange',
		'LaGrange',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.102.106:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'LAMAR_CNTY_IND',
		'Lamar Cnty Ind 115 DF/SE  GPC',
		'Lamar Cnty Ind 115 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.105.238:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'LAWRENCEVILLE',
		'Lawrenceville DME',
		'Lawrenceville DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.166.151:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'LITTLE_OGEECHEE',
		'Little Ogeechee 230/115kV DME',
		'Little Ogeechee 230/115kV DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.156.8:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'LIVE_OAK',
		'Live Oak DME',
		'Live Oak DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.77.202:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'LOOPERS_FARM',
		'Looper''s Farm 230 DF/SE DALTON',
		'Looper''s Farm 230 DF/SE DALTON',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.110.28:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'MAGNOLIA',
		'Magnolia 115/46kV DME GPC',
		'Magnolia 115/46kV DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.162.234:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'MCGRAU_FORD_230',
		'McGrau Ford 230 DF/SE 1 GPC',
		'McGrau Ford 230 DF/SE 1 GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.165.170:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'MCGRAU_FORD_500',
		'McGrau Ford 500 DF/SE  2  GPC',
		'McGrau Ford 500 DF/SE  2  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.165.169:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'MCINTOSH_115',
		'McIntosh 115kV DF/SE  GPC',
		'McIntosh 115kV DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.160.202:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'MCINTOSH_230',
		'McIntosh 230kV DF/SE GPC',
		'McIntosh 230kV DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.160.201:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'MCMANUS',
		'McManus GPC DME',
		'McManus GPC DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.165.215:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'MELDRIM',
		'Meldrim 230/115 DF/SE  GPC',
		'Meldrim 230/115 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.152.234:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'MILLEN_PRI',
		'Millen Pri 115/46 DF/SE  GPC',
		'Millen Pri 115/46 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.81.240:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'MITCHELL_115',
		'Mitchell 115kV DME GPC',
		'Mitchell 115kV DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.173.56:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'MITCHELL_230',
		'Mitchell 230 DME GPC',
		'Mitchell 230 DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.172.218:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'MOSSY_BRANCH',
		'Mossy Branch',
		'Mossy Branch',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.158.106:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'N.TIFTON_115',
		'N.Tifton 115 DF/SE  GPC',
		'N.Tifton 115 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.165.106:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'N.TIFTON_500',
		'N.Tifton 500 DF/SE 1 GPC',
		'N.Tifton 500 DF/SE 1 GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.161.250:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'NELSON',
		'Nelson',
		'Nelson',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.83.201:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'NORCROSS_115',
		'Norcross 115KV',
		'Norcross 115KV',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.159.234.:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'NORCROSS_230',
		'Norcross 230KV',
		'Norcross 230KV',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.159.233:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'NORCROSS_500',
		'Norcross 500kV DME',
		'Norcross 500kV DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.159.230:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'NORCROSS_500/230_DF/SE_GPC',
		'Norcross 500/230 DF/SE  GPC',
		'Norcross 500/230 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.159.230:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'NORTH_TIFTON_230',
		'North Tifton 230kV DME',
		'North Tifton 230kV DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.170.42:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'NORTHWEST_115',
		'NORTHWEST 115KV',
		'NORTHWEST 115KV',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.175.74:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'NORTHWEST_230',
		'Northwest 230kV',
		'Northwest 230kV',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.163.10:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'NORTHWINDS',
		'Northwinds DME GPC',
		'Northwinds DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.106.214:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'OFFERMAN',
		'Offerman 230/115kV DME GPC',
		'Offerman 230/115kV DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.171.170:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'OOSTANAULA',
		'Oostanaula',
		'Oostanaula',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.111.193:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PALMYRA',
		'Palmyra 230/115kV DME GPC',
		'Palmyra 230/115kV DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.113.116:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PATSILIGA_CREEK',
		'Patsiliga Creek DME',
		'Patsiliga Creek DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.77.223:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PEGAMORE',
		'Pegamore 230 DF/SE  GPC',
		'Pegamore 230 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.106.44:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PINE_GROVE_PRIMARY',
		'Pine Grove Primary 230/115kV GPC',
		'Pine Grove Primary 230/115kV GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.110.123:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PINSON',
		'Pinson DME GPC',
		'Pinson DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.72.231:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PITTMAN_ROAD',
		'Pittman Road',
		'Pittman Road',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.100.142:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PITTS',
		'Pitts 230/115kV (MEAG)',
		'Pitts 230/115kV (MEAG)',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.105.245:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PLT_BOWEN_230',
		'Plt Bowen 230 DF/SE  GPC New',
		'Plt Bowen 230 DF/SE  GPC New',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.170.58:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PLT_BOWEN_500',
		'Plt Bowen 500 DF/SE GPC',
		'Plt Bowen 500 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.175.250:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PLT_MCDONOUGH',
		'Plt McDonough 230/115 DF/SE  GPC',
		'Plt McDonough 230/115 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.173.42:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PLT_VOGTLE_SWYD_230',
		'Plt Vogtle Swyd 230 DF/SE 1 GPC',
		'Plt Vogtle Swyd 230 DF/SE 1 GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.168.168:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PLT_VOGTLE_SWYD_500',
		'Plt Vogtle Swyd 500 DF/SE #2 GPC',
		'Plt Vogtle Swyd 500 DF/SE #2 GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.168.169:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PORTERDALE',
		'Porterdale 230/115 DF/SE GPC',
		'Porterdale 230/115 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.105.219:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PORTLAND',
		'Portland Sub',
		'Portland Sub',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.105.161:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'RACHELS_POND',
		'Rachels Pond DME',
		'Rachels Pond DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.82.153:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'RIGGINS_MILL',
		'RIGGINS MILL 230kV DME',
		'RIGGINS MILL 230kV DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.170.10:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'ROCK_SPRING',
		'Rock Spring 230/115 DF/SE GPC',
		'Rock Spring 230/115 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.173.138:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'ROCKY_CREEK',
		'Rocky Creek DME',
		'Rocky Creek DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.101.211:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'RUSTIN_LAKE',
		'Rustin Lake DME',
		'Rustin Lake DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.77.224:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'S.AUGUSTA',
		'S.Augusta 230/115 DF/SE  GPC',
		'S.Augusta 230/115 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.160.67:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'S.HALL_230',
		'S.Hall 230 DF/SE  GPC',
		'S.Hall 230 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.162.154:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'S.HALL_500',
		'S.Hall 500 DF/SE  GPC',
		'S.Hall 500 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.162.153:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'SAVAGE_CREEK',
		'Savage Creek DME',
		'Savage Creek DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.109.186:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'SCHERER_COMMON',
		'SCHERER COMMON 500kV',
		'SCHERER COMMON 500kV',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.173.231:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'SCOOTER',
		'Scooter',
		'Scooter',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.106.195:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'SCOTTDALE',
		'Scottdale 230KV DME',
		'Scottdale 230KV DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.155.250:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'SHOAL_CREEK',
		'Shoal Creek DF/SE GPC',
		'Shoal Creek DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.106.17:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'SNELLVILLE_PRI',
		'Snellville Pri 230/115 DF/SE GPC',
		'Snellville Pri 230/115 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.106.18:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'SOUTH_BAINBRIDGE',
		'South Bainbridge 230 DF/SE GPC',
		'South Bainbridge 230 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.175.26:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'SOUTH_COLUMBUS',
		'South Columbus GPC DME',
		'South Columbus GPC DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.104.42:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'SOUTH_MACON',
		'South Macon DF/SE GPC',
		'South Macon DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.141.98:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'SPRINGHILL_CHURCH',
		'Springhill Church DME',
		'Springhill Church DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.81.94:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'STATESBORO',
		'Statesboro Pri DME GPC',
		'Statesboro Pri DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.102.241:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'STUMP_CREEK',
		'Stump Creek 230/115 DF/SE  GPC',
		'Stump Creek 230/115 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.110.76:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'SUN_HILL',
		'Sun Hill DME',
		'Sun Hill DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.82.144:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'SUWANEE',
		'Suwanee 230/115 DF/SE GPC',
		'Suwanee 230/115 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.106.19:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'TALLULAH_LODGE',
		'Tallulah Lodge 115kV DF/SE GPC',
		'Tallulah Lodge 115kV DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.159.105:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'TENASKA',
		'Tenaska 500 DF/SE  GPC',
		'Tenaska 500 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.156.89:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'TERRORA_COMMON',
		'Terrora Common DME',
		'Terrora Common DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.151.73:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'THALMAN_500KV',
		'Thalman 500kV',
		'Thalman 500kV',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.159.58:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'THALMANN_230',
		'Thalmann 230kV',
		'Thalmann 230kV',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.159.57:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'THOMASTON',
		'Thomaston 230/115 SE  GPC',
		'Thomaston 230/115 SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.10.176:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'THOMASVILLE',
		'Thomasville 230/115 DF/SE MEAG',
		'Thomasville 230/115 DF/SE MEAG',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.106.10:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'THOMPSON_PRIMARY_230KV',
		'THOMPSON PRIMARY 230kV',
		'THOMPSON PRIMARY 230kV',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.172.55:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'THOMSON_PRIMARY_500',
		'Thomson 500/230 DF/SE GPC',
		'Thomson 500/230 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.172.138:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'TOCCOA',
		'Toccoa-GPC',
		'Toccoa-GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.110.115:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'TUNNEL_HILL',
		'Tunnel Hill',
		'Tunnel Hill',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.115.179:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'VIDALIA',
		'Vidalia DME GPC',
		'Vidalia DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.172.250:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'VOGTLE_230KV_SWITCHING_SS',
		'Vogtle 230kV Switching SS GPC',
		'Vogtle 230kV Switching SS GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.168.186:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'VOGTLE_3_AND_4',
		'Vogtle 3 and 4 500kV DF/SE',
		'Vogtle 3 and 4 500kV DF/SE',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.167.42:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'WADLEY_PRI_230',
		'Wadley Pri DME MEAG',
		'Wadley Pri DME MEAG',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.174.88:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'WADLEY_PRIMARY_500',
		'Wadley Primary 500 DME GPC',
		'Wadley Primary 500 DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.174.170:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'WARRENTON_PRI',
		'Warrenton Pri 230/115 DF/SE GPC',
		'Warrenton Pri 230/115 DF/SE GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.105.240:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'WARTHEN',
		'Warthen 500 DF/SE  GPC',
		'Warthen 500 DF/SE  GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.156.106:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'WAYNESBORO_PRI',
		'Waynesboro Pri 230/115kV',
		'Waynesboro Pri 230/115kV',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.172.250:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'WELLSTON',
		'Wellston DME',
		'Wellston DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.113.8:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'WEST_BRUNSWICK',
		'West Brunswick DME GPC',
		'West Brunswick DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.168.106:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'WEST_MCINTOSH',
		'West McIntosh DME',
		'West McIntosh DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.154.202:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'WEST_MILLEDGEVILLE',
		'West Milledgeville GPC DF/SE',
		'West Milledgeville GPC DF/SE',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.104.68:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'WEST_VALDOSTA',
		'West Valdosta DME GPC',
		'West Valdosta DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.110.121:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'WILSON_CT',
		'Wilson CT GPC DME',
		'Wilson CT GPC DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.169.118:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'WIREGRASS',
		'Wiregrass 230-DME',
		'Wiregrass 230-DME',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-601'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.82.40:216; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'App DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'YATES_COMMON',
		'Yates Common DME GPC',
		'Yates Common DME GPC',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'USI 2002'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.27.167.90:21; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'USI DFR'),'; schedule=0 13 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'CREEKSIDE_HIGHSCHOOL_PRIMARY',
		'Creekside High School Primary Meter',
		'Creekside High School Primary Meter',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-501'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.180.97:2001; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'ION'),'; schedule=0 11 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'INTERFOR_THOMASTON_PRIMARY',
		'Interfor Thomaston Primary Meter',
		'Interfor Thomaston Primary Meter',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-501'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.169.125:2001; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'ION'),'; schedule=0 11 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'ZCOLO_DATABANK_CASCADEHEIGHTS',
		'ZCOLO Databank Cascade Heights',
		'ZCOLO Databank Cascade Heights',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-501'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.163.233:2001; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'ION'),'; schedule=0 11 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'ZCOLO_DATABANK_UNIVERSITYCTR',
		'ZCOLO Databank University Center',
		'ZCOLO Databank University Center',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-501'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.163.247:2001; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'ION'),'; schedule=0 11 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'VULCAN_CONSTRUCTION_JULIETTE',
		'Vulcan Construction Materials Juliette',
		'Vulcan Construction Materials Juliette',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'Southern Company'),
		0,
		(SELECT ID FROM VendorDevice WHERE Name LIKE 'APP-501'),
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		(SELECT CONCAT('ftpType=0; connectionHostName=10.34.168.215:2001; connectionUserName=anonymous; connectionPassword=[REDACTED] connectionProfileID=',(SELECT ID FROM ConnectionProfile WHERE Name LIKE 'ION'),'; schedule=0 11 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false')),
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
